How to: Add dollar signs to numbers in a spreadsheet.
Solution:
Select the cell or range of cells containing the numbers, select 'Cells...' from the 'Format' menu, select 'Currency' on the 'Number' properties sheet, and select the 'Use $' check box.
1) Click once on the cell or range with the numbers to format.
2) Select the 'Format' menu and select 'Cells...'. (The Format Cells dialog box appears.)
3) Click the 'Number' tab.
4) Select 'Currency' from the 'Category' list box.
5) Select the 'Use $' check box.
6) (Optional) Adjust the decimal places for the numbers in the 'Decimal Places' box.
7) (Optional) Select the format for negative numbers in the 'Negative Numbers' list box.
8) Click 'OK'.
